diff options
Diffstat (limited to 'app/api/projects/[projectId]/cover')
| -rw-r--r-- | app/api/projects/[projectId]/cover/route.ts | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/app/api/projects/[projectId]/cover/route.ts b/app/api/projects/[projectId]/cover/route.ts new file mode 100644 index 00000000..b88f06ee --- /dev/null +++ b/app/api/projects/[projectId]/cover/route.ts @@ -0,0 +1,73 @@ +// app/api/projects/[projectId]/cover/route.ts +import { NextRequest, NextResponse } from "next/server" +import db from "@/db/db" +import { projectCoverTemplates, generatedCoverPages } from "@/db/schema" +import { eq, and, desc } from "drizzle-orm" + +export async function GET( + request: NextRequest, + { params }: { params: { projectId: string } } +) { + try { + const projectId = parseInt(params.projectId) + + if (isNaN(projectId)) { + return NextResponse.json( + { success: false, message: "유효하지 않은 프로젝트 ID입니다" }, + { status: 400 } + ) + } + + // 1. 해당 프로젝트의 활성 템플릿 찾기 + const [activeTemplate] = await db + .select() + .from(projectCoverTemplates) + .where( + and( + eq(projectCoverTemplates.projectId, projectId), + eq(projectCoverTemplates.isActive, true) + ) + ) + .limit(1) + + if (!activeTemplate) { + return NextResponse.json( + { success: false, message: "활성 템플릿을 찾을 수 없습니다" }, + { status: 404 } + ) + } + + // 2. 해당 템플릿의 최신 생성된 커버 페이지 찾기 + const [latestCover] = await db + .select() + .from(generatedCoverPages) + .where(eq(generatedCoverPages.templateId, activeTemplate.id)) + .orderBy(desc(generatedCoverPages.generatedAt)) + .limit(1) + + if (!latestCover) { + return NextResponse.json( + { success: false, message: "생성된 커버 페이지를 찾을 수 없습니다" }, + { status: 404 } + ) + } + + // 3. 파일 경로와 정보 반환 + return NextResponse.json({ + success: true, + fileUrl: latestCover.filePath, + fileName: latestCover.fileName, + generatedAt: latestCover.generatedAt, + }) + + } catch (error) { + console.error("❌ 커버 페이지 조회 오류:", error) + return NextResponse.json( + { + success: false, + message: error instanceof Error ? error.message : "조회 중 오류 발생" + }, + { status: 500 } + ) + } +}
\ No newline at end of file |
